Adding a New Look-Up Table

A new Look-up table can be created and the data entered manually or imported from a .CSV or Excel file.

With a creative open in the Overview screen, select the Look-Up Tables Tab at the bottom of the screen:

Click the New button to open the New Look-Up Table screen:

Enter the Look-Up table name, and description if required.

A Look-Up table with a Key column, and Value column is created.

The Key column is mandatory and cannot be deleted.

Manually Enter Data

To change the name of the Key or Value column:

1. Click the drop-down arrow on the column name.
2. Select Update Name.
3. Enter the new column name and click OK.

New columns can be added if required, by clicking the New Column button.

To add a new row, click the button.

Enter the required data in the new row.

To delete a row, select it and click the button.

Click Save once the Look-Up table is completed, the look-up table will be added to the Look-Up Tables tab.

Import Data

Click the Import Data button.

Click the Browse button to open a file explorer window and navigate to a CSV or Excel file.

Select the required file and click Open.

CSV File

If you select CSV, the Column Delimeter and the Text Qualifier are automatically detected and can be amended. By default the first row of your CSV file is set as the column headings. The data will import with a sample preview showing the first 10 rows of your file. If there are more than 10 rows in your file these are not shown here.

Excel File

If importing an Excel file, select the relevant sheet.

Click Next.

Change the Look-Up key if required by clicking on the drop-down arrow next to the Key field and select the required column.

The Look-Up key, by default, is based on the first column.

Import Columns

Uncheck any columns that you do not want to import into the Look-Up table.

If you are importing the data for the first time you will see text boxes in the Import As column. These text boxes allow you to rename the column headers in the look-up table data. If you are importing data into an existing Look-Up Table you will see drop-down arrows in the Import As column. The drop-downs allow you to map the columns from the selected file to the columns in the Look-Up Table.

Click Done.

A message will be displayed showing the imported data details:

Click OK to clear this message and the preview will be shown in the New Look-Up Table screen:

if required new data can be added to the imported data, or existing data removed.

To add a new row, click the button.

Enter the required data in the new row.

To delete a row, select it and click the button.

Click the Done button to close the window, the look-up table will be added to the Look-Up Tables tab.

• Look-Up Tables
  • Adding a New Look-Up Table
  • Importing Look-Up Tables From Another Creative
  • Re-importing a file into a Look-Up Table
  • Editing Look-Up Tables
  • Deleting Look-Up Tables
  • Using Look-Up Tables
  • Exporting a Look-Up Table